/*
Navicat SQL Server Data Transfer

Source Server         : LOCALHOST
Source Server Version : 110000
Source Host           : .:1433
Source Database       : AAACHAM2
Source Schema         : dbo

Target Server Type    : SQL Server
Target Server Version : 110000
File Encoding         : 65001

Date: 2014-05-12 10:39:55
*/


-- ----------------------------
-- Table structure for tb0002
-- ----------------------------
DROP TABLE [dbo].[tb0002]
GO
CREATE TABLE [dbo].[tb0002] (
[TableID] varchar(20) NOT NULL ,
[IsAutomatic] tinyint NOT NULL DEFAULT ((0)) ,
[IsS1] tinyint NOT NULL DEFAULT ((0)) ,
[IsS2] tinyint NOT NULL DEFAULT ((0)) ,
[IsS3] tinyint NOT NULL DEFAULT ((0)) ,
[S1] varchar(20) NULL ,
[S2] varchar(20) NULL ,
[S3] varchar(20) NULL ,
[Length] tinyint NULL ,
[OutputOrder] tinyint NULL ,
[IsSeparator] tinyint NULL ,
[Separator] varchar(1) NULL 
)


GO

-- ----------------------------
-- Records of tb0002
-- ----------------------------
INSERT INTO [dbo].[tb0002] ([TableID], [IsAutomatic], [IsS1], [IsS2], [IsS3], [S1], [S2], [S3], [Length], [OutputOrder], [IsSeparator], [Separator]) VALUES (N'tb0045', N'1', N'1', N'1', N'1', N'CC', N'SG', N'ZZ', N'10', N'3', N'0', N'')
GO
GO
INSERT INTO [dbo].[tb0002] ([TableID], [IsAutomatic], [IsS1], [IsS2], [IsS3], [S1], [S2], [S3], [Length], [OutputOrder], [IsSeparator], [Separator]) VALUES (N'tb0054', N'1', N'1', N'1', N'0', N'DT', N'NK', N'', N'15', N'3', N'0', N'')
GO
GO
INSERT INTO [dbo].[tb0002] ([TableID], [IsAutomatic], [IsS1], [IsS2], [IsS3], [S1], [S2], [S3], [Length], [OutputOrder], [IsSeparator], [Separator]) VALUES (N'tb2554', N'1', N'1', N'1', N'0', N'A', N'E', N'', N'6', N'3', N'0', N'')
GO
GO
INSERT INTO [dbo].[tb0002] ([TableID], [IsAutomatic], [IsS1], [IsS2], [IsS3], [S1], [S2], [S3], [Length], [OutputOrder], [IsSeparator], [Separator]) VALUES (N'tb0083', N'1', N'1', N'1', N'1', N'D', N'M', N'N', N'8', N'0', N'1', N'-')
GO
GO

-- ----------------------------
-- Indexes structure for table tb0002
-- ----------------------------

-- ----------------------------
-- Primary Key structure for table tb0002
-- ----------------------------
ALTER TABLE [dbo].[tb0002] ADD PRIMARY KEY NONCLUSTERED ([TableID])
GO
